Optimizing MySQL performance, troubleshooting MySQL problems, and managing backups are the most critical and challenging tasks for MySQL DBAs in their daily routine. The databases powering your applications need to be able to handle changing traffic workloads while remaining responsive and stable so that you can deliver an excellent user experience. At the same time, modern database vendors demonstrate a trend of moving away from traditional deployment methods to DBaaS, which means DBAs are also expected to find cost-efficient means of solving these issues.

In this presentation, we will demonstrate the advanced options of PMM that enable you to solve these challenges. We will show how to get the DBaaS experience built on free and open-source software. We will look at specific, common MySQL problems and review them.